---
title: DB-CLL-016 — Retrieve case notes for a legal case
summary: Retrieve case notes for a legal case
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-016 — Retrieve case notes for a legal case

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-016 |
| Operation type | R |
| Execution method | StoredProc |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Stored procedure call |
| Business object | clsCaseNote |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier used to filter notes |
| RefCursor | Output (Cursor) | REF CURSOR | N/A | Result set of matching case note rows |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [CASE_NOTE](../database-tables.md#case_note) | SELECT | LegalCaseID filter, cursor result set |

## Sample SQL

```sql
EXEC Pk80001_Legalnet.GetCaseNote(:LegalCaseID, :RefCursor OUT);
```

## Operations and processes

- [Manage case notes](../operations/manage-case-note.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb`